----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  Z:\GWA4 - Cantoni\D_Ergebnisse\evs98_cantoni_20140812tables5_6.log
  log type:  text
 opened on:  12 Aug 2014, 11:30:47

. 
. ***************************************************************************
. ***************************************************************************
. *** Titel des Projekts: <Clueless? The impact of television on consumption behavior.>
. *** Datengrundlage: <EVS 1998>
. *** Dateiname des Programmcodes: evs98_cantoni_20140812tables5_6.do
. *** erstellt: <2014/08/12> 
. *** von: <Davide Cantoni> 
. *** E-Mail: <cantoni@lmu.de> 
. *** Tel.: <0176/21816773> 
. *** Dateiname der Output-Files: <evs98_cantoni_20140812tables5_6.log> 
. ***                     <evs98_cantoni_20140812tables5_6.txt>  
. *** 
. *** Grundriss des Programms: <Programm zur Untersuchung von 
. *** Unterschieden im Konsumverhalten zwischen ehem. DDR-Regionen mit Zugang 
. *** zu westlichen Fernsehsendern und solchen ohne.>
. *** 
. *** Verwendete Variablen: 
. *** Originalvariablen:  <mehrere>
. *** 
. *** Neu angelegte Variablen: <bula*: Bundesland-Dummy
. ***                             berlinost: Dummy fuer Haushalte in Ostberlin
. ***                             smallcity: Kleinstadt-Dummy
. ***                             age: Ungefaehres Alter 
. ***                             agesq: (Ungefaehres Alter)^2
. ***                             single: Alleinstehend-Dummy
. ***                             german: Dummy fuer deutsche Nationalitaet
. ***                             female: Dummy fuer Frauen
. ***                             employed: Dummy fuer Vollzeitbeschaeftigte 
. ***                             retired: Dummy fuer Rentner 
. ***                             onwelfare: Dummy fuer Sozialhilfeempfaenger 
. ***                             treat: Neucodierung von ard_signalstaerke
. ***                     netincome: Umbenennung von ef20
. ***                     disposableincome: Umbenennung von ef21
. ***                     weight: Umbenennung von ef95
. ***                             ef100001-ef100014: Konsumausgaben, fuer die Werbungsinformationen bereitstehen
. ***                             ef100015: Uebrige Konsumausgaben (ohne Werbung)
. ***                             ef: Konsumausgaben (nach Umformung des Datensatzes)
. ***                             logef: Logarithmus der Konsumausgaben (nach Umformung des Datensatzes)
. ***                             log0ef: Logarithmus der Konsumausgaben+1 (nach Umformung des Datensatzes)>
. ***
. *** Gewichtungsvariablen: <ef95: Umbenannt als "weight">
. ***
. ***************************************************************************
. ***************************************************************************
. 
.         
.         **** Version festlegen
. 
. version 9.1

. 
.         **** Bildschirmausgabe steuern
. 
. set more off

. 
.         **** Arbeitsspeicher festlegen
. 
. set mem 750m

. 
.         **** Arbeitsverzeichnis festlegen
. 
. cd "Z:\GWA4 - Cantoni\D_Ergebnisse\"
Z:\GWA4 - Cantoni\D_Ergebnisse

. 
.         **** Datensatz vorbereiten
. 
. qui do "Z:\GWA4 - Cantoni\C_Programm\evs98_cantoni_20140812preparedata.do"

. 
.         *** Aggregiertes Konsumverhalten 
.         *** (aggregate consumption behavior - Table 5)
. 
. drop if berlinost==1
(1112 observations deleted)

. 
. tab treat saving01

           |       saving01
     treat |         0          1 |     Total
-----------+----------------------+----------
         0 |       365      1,282 |     1,647 
         1 |     2,343      7,804 |    10,147 
-----------+----------------------+----------
     Total |     2,708      9,086 |    11,794 


. 
. replace ln_dispincome=100*ln_dispincome
(11794 real changes made)

. replace ln_ef100100=100*ln_ef100100
(11794 real changes made)

. replace saving01=100*saving01
(9086 real changes made)

. 
. local controls "treat ln_dispincome age agesq kids single female german employed retired onwelfare bula* smallcity [w=weight]"

. 
. reg ln_dispincome treat age agesq kids single female german employed retired onwelfare bula* smallcity [w=weight], robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.1808e+06)

Linear regression                                      Number of obs =   11794
                                                       F( 15,  1895) =  540.51
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.5540
                                                       Root MSE      =  38.054

                                (Std. Err. adjusted for 1896 clusters in muni)
------------------------------------------------------------------------------
             |               Robust
ln_dispinc~e |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
       treat |  -2.169856   1.960024    -1.11   0.268    -6.013888    1.674176
         age |   2.579125   .2618962     9.85   0.000      2.06549    3.092761
       agesq |  -.0201881   .0025598    -7.89   0.000    -.0252084   -.0151677
        kids |   5.073544   .7142031     7.10   0.000     3.672837    6.474251
      single |  -60.54395    1.46564   -41.31   0.000    -63.41839   -57.66952
      female |  -5.865417   1.139224    -5.15   0.000    -8.099682   -3.631152
      german |   17.85415   4.278477     4.17   0.000     9.463131    26.24517
    employed |   50.55052   1.898667    26.62   0.000     46.82682    54.27422
     retired |   13.53827   2.434047     5.56   0.000     8.764579    18.31197
   onwelfare |  -31.58684    3.88135    -8.14   0.000    -39.19901   -23.97467
       bula1 |   1.366185   1.882594     0.73   0.468    -2.325989    5.058359
       bula2 |  -4.654614   2.076842    -2.24   0.025    -8.727751   -.5814765
       bula3 |  -.1030396   1.713455    -0.06   0.952    -3.463495    3.257416
       bula4 |   -.990935   1.651201    -0.60   0.548    -4.229298    2.247427
       bula5 |          0  (omitted)
       bula6 |          0  (omitted)
   smallcity |   10.98646   1.300501     8.45   0.000     8.435898    13.53703
       _cons |   821.7398    8.45026    97.24   0.000      805.167    838.3126
------------------------------------------------------------------------------

.         outreg2 using evs98_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") replace
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. reg ln_ef100100 `controls', robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.1808e+06)

Linear regression                                      Number of obs =   11794
                                                       F( 16,  1895) =  810.40
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.6586
                                                       Root MSE      =  32.235

                                 (Std. Err. adjusted for 1896 clusters in muni)
-------------------------------------------------------------------------------
              |               Robust
  ln_ef100100 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
        treat |   .6180279   1.169838     0.53   0.597    -1.676277    2.912333
ln_dispincome |    .685188   .0175332    39.08   0.000     .6508016    .7195744
          age |   1.265987   .2071949     6.11   0.000      .859633    1.672341
        agesq |  -.0127332   .0019429    -6.55   0.000    -.0165436   -.0089229
         kids |   2.889043   .5883191     4.91   0.000     1.735222    4.042864
       single |  -13.72777   1.749274    -7.85   0.000    -17.15848   -10.29707
       female |   .5653254   .9462162     0.60   0.550     -1.29041     2.42106
       german |   2.964131   4.106176     0.72   0.470     -5.08897    11.01723
     employed |  -.8202296   1.457509    -0.56   0.574    -3.678721    2.038262
      retired |   4.450052   1.769421     2.51   0.012      .979834    7.920269
    onwelfare |  -3.048744   2.163825    -1.41   0.159    -7.292472    1.194985
        bula1 |  -1.799431   1.254899    -1.43   0.152    -4.260561    .6616982
        bula2 |  -3.555661    1.33205    -2.67   0.008    -6.168099   -.9432233
        bula3 |  -2.479909   1.405396    -1.76   0.078    -5.236195    .2763774
        bula4 |  -4.234165   1.249011    -3.39   0.001    -6.683746   -1.784583
        bula5 |          0  (omitted)
        bula6 |          0  (omitted)
    smallcity |   .4794485   1.026659     0.47   0.641    -1.534051    2.492948
        _cons |    243.068   18.22119    13.34   0.000     207.3323    278.8037
-------------------------------------------------------------------------------

.         outreg2 using evs98_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") 
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. reg saving01 `controls', robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.1808e+06)

Linear regression                                      Number of obs =   11794
                                                       F( 16,  1895) =   32.74
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.0980
                                                       Root MSE      =  42.333

                                 (Std. Err. adjusted for 1896 clusters in muni)
-------------------------------------------------------------------------------
              |               Robust
     saving01 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
        treat |   -1.50091    1.40885    -1.07   0.287    -4.263971     1.26215
ln_dispincome |   .1731068   .0165909    10.43   0.000     .1405684    .2056453
          age |  -.2152416   .2880554    -0.75   0.455    -.7801806    .3496974
        agesq |    .000039   .0029814     0.01   0.990    -.0058082    .0058862
         kids |  -.3549735   .6319642    -0.56   0.574    -1.594392    .8844452
       single |  -.5232576   1.745033    -0.30   0.764    -3.945646    2.899131
       female |  -1.030367   1.162948    -0.89   0.376     -3.31116    1.250427
       german |   20.28582   12.64505     1.60   0.109    -4.513859     45.0855
     employed |   8.898958   2.082697     4.27   0.000     4.814338    12.98358
      retired |   3.642752   2.665549     1.37   0.172    -1.584967     8.87047
    onwelfare |  -4.583583    5.95556    -0.77   0.442    -16.26373    7.096561
        bula1 |   2.795062   2.142419     1.30   0.192    -1.406686     6.99681
        bula2 |    5.91505   2.318851     2.55   0.011      1.36728    10.46282
        bula3 |   4.493338   1.940466     2.32   0.021     .6876631    8.299013
        bula4 |   8.122607   2.099808     3.87   0.000     4.004429    12.24079
        bula5 |          0  (omitted)
        bula6 |          0  (omitted)
    smallcity |   .3803595    1.32881     0.29   0.775    -2.225725    2.986444
        _cons |  -105.2523   20.10894    -5.23   0.000    -144.6903   -65.81429
-------------------------------------------------------------------------------

.         outreg2 using evs98_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") 
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. 
.         *** Kreditaufnahme
.         *** (credit taking behavior)
. 
. tab treat int_conscredit01 

           |   int_conscredit01
     treat |         0          1 |     Total
-----------+----------------------+----------
         0 |     1,240        407 |     1,647 
         1 |     7,308      2,839 |    10,147 
-----------+----------------------+----------
     Total |     8,548      3,246 |    11,794 


. tab treat int_overdraft01

           |    int_overdraft01
     treat |         0          1 |     Total
-----------+----------------------+----------
         0 |     1,460        187 |     1,647 
         1 |     9,002      1,145 |    10,147 
-----------+----------------------+----------
     Total |    10,462      1,332 |    11,794 


. 
. replace int_conscredit01=100*int_conscredit01
(3246 real changes made)

. replace int_overdraft01=100*int_overdraft01
(1332 real changes made)

. 
. reg int_conscredit01 `controls', robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.1808e+06)

Linear regression                                      Number of obs =   11794
                                                       F( 16,  1895) =   68.85
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.0897
                                                       Root MSE      =  40.649

                                 (Std. Err. adjusted for 1896 clusters in muni)
-------------------------------------------------------------------------------
              |               Robust
int_conscr~01 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
        treat |  -1.416203   1.749251    -0.81   0.418    -4.846863    2.014458
ln_dispincome |    .058461   .0127676     4.58   0.000      .033421    .0835011
          age |   .1171263   .2132212     0.55   0.583    -.3010467    .5352992
        agesq |  -.0062765    .001913    -3.28   0.001    -.0100283   -.0025246
         kids |    3.84832   .8030577     4.79   0.000      2.27335     5.42329
       single |  -.2038485   1.422368    -0.14   0.886    -2.993421    2.585724
       female |  -.6351452    1.11865    -0.57   0.570    -2.829061    1.558771
       german |  -4.718515   8.575456    -0.55   0.582    -21.53684    12.09981
     employed |   6.996741   1.882511     3.72   0.000      3.30473    10.68875
      retired |    6.02871    1.78357     3.38   0.001     2.530743    9.526678
    onwelfare |  -6.105847   4.948883    -1.23   0.217    -15.81168    3.599985
        bula1 |   1.499651   1.519686     0.99   0.324    -1.480782    4.480084
        bula2 |  -1.524569   1.464708    -1.04   0.298    -4.397178    1.348041
        bula3 |  -1.870143   1.461546    -1.28   0.201     -4.73655    .9962648
        bula4 |   1.079608    1.53865     0.70   0.483    -1.938018    4.097233
        bula5 |          0  (omitted)
        bula6 |          0  (omitted)
    smallcity |  -1.337635   1.186811    -1.13   0.260    -3.665228    .9899581
        _cons |  -18.46526   14.30905    -1.29   0.197     -46.5284    9.597881
-------------------------------------------------------------------------------

.         outreg2 using evs98_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") 
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. reg int_overdraft01 `controls', robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.1808e+06)

Linear regression                                      Number of obs =   11794
                                                       F( 16,  1895) =   29.88
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.0478
                                                       Root MSE      =  29.181

                                 (Std. Err. adjusted for 1896 clusters in muni)
-------------------------------------------------------------------------------
              |               Robust
int_overdr~01 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
        treat |   -1.53875   1.031178    -1.49   0.136    -3.561114    .4836142
ln_dispincome |   .0334263   .0105651     3.16   0.002     .0127058    .0541469
          age |  -.1347517   .1539234    -0.88   0.381    -.4366288    .1671255
        agesq |  -.0015181   .0013362    -1.14   0.256    -.0041388    .0011025
         kids |   2.063602   .5647664     3.65   0.000     .9559724    3.171231
       single |   4.883651   1.215342     4.02   0.000     2.500103    7.267199
       female |  -.9234899   .8633589    -1.07   0.285    -2.616724    .7697441
       german |   6.762384   6.684647     1.01   0.312    -6.347656    19.87242
     employed |   1.803202   1.526453     1.18   0.238    -1.190504    4.796907
      retired |   .4285477   1.495901     0.29   0.775    -2.505239    3.362334
    onwelfare |   12.17525   6.110573     1.99   0.046     .1910964    24.15941
        bula1 |  -2.137036   1.349856    -1.58   0.114    -4.784396    .5103246
        bula2 |  -4.235186   1.138075    -3.72   0.000    -6.467198   -2.003175
        bula3 |  -2.917456   1.111288    -2.63   0.009    -5.096933   -.7379791
        bula4 |  -2.372083    1.12672    -2.11   0.035    -4.581825   -.1623399
        bula5 |          0  (omitted)
        bula6 |          0  (omitted)
    smallcity |  -2.160695   .8224192    -2.63   0.009    -3.773637   -.5477524
        _cons |  -15.43953   12.06651    -1.28   0.201    -39.10456    8.225504
-------------------------------------------------------------------------------

.         outreg2 using evs98_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") 
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. 
. log close
      name:  <unnamed>
       log:  Z:\GWA4 - Cantoni\D_Ergebnisse\evs98_cantoni_20140812tables5_6.log
  log type:  text
 closed on:  12 Aug 2014, 11:30:52
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
